/**
 * CircleMemberTableMetaData.java
 * com.jamin.aabill.db
 *
 * Function： TODO 
 *
 *   ver     date      		author
 * ──────────────────────────────────
 *   		 2012-8-20 		wangjieming
 *
 * Copyright (c) 2012, TNT All Rights Reserved.
 */

package com.jamin.aabill.db;

import android.provider.BaseColumns;

/**
 * ClassName:CircleMemberTableMetaData
 *
 * @author   wangjieming
 * @version  1.0
 * @since    v1.0
 * @Date	 2012-8-20 上午9:30:42 
 */
public class CircleMemberTableMetaData implements BaseColumns {



	public static final String TABLE_NAME = "circlemember";
	public static final String CIRCLE_ID  = "circle_id";
	public static final String NAME  = "name";
	public static final String MOBILE  = "mobile";
	public static final String DESCRIPTION  = "description";
	public static final String SORT_KEY  = "sort_key";
	public static final String ACTIVE  = "active";
	public static final String CREATE_AT  = "create_at";



	public static final String CREATE_TABLE_SQL =  "CREATE TABLE IF NOT EXISTS "
			+ TABLE_NAME + "(" 
			+ _ID+ " INTEGER PRIMARY KEY," 
			+ CIRCLE_ID + " INTEGER," 
			+ NAME + " TEXT," 
			+ MOBILE + " TEXT," 
			+ DESCRIPTION + " INTEGER," 
			+ SORT_KEY + " TEXT,"
			+ ACTIVE + " INTEGER,"
			+ CREATE_AT + " INTEGER" 
			+ ");";



	public static final String DROP_TABLE_SQL = "DROP TABLE IF EXISTS "+ TABLE_NAME;


}